
/*
Nombre		: pvServiciosHdr
Descripcion	: Tabla de encabezado para servicios
Fecha		: 2006/11/13
Creada por	: LI. Jose Delgado Rguez
*/

CREATE TABLE dbo.pvServiciosHdr(
	[Empresa] [varchar] (10) NOT NULL ,
	[Regional] [varchar] (10) NOT NULL ,
	[Sucursal] [varchar] (10) NOT NULL ,
	[Folio] [varchar] (10) NOT NULL ,
	[FolioVta] [varchar] (10) NOT NULL ,
	[Status] [varchar] (2) NOT NULL ,
	[Fecha] [smalldatetime] NOT NULL ,
	[Tipo] [varchar] (1) NOT NULL ,
	[DescripFalla] [varchar] (300) NOT NULL ,
	CONSTRAINT [pvGarantiasHdr0] PRIMARY KEY  NONCLUSTERED 
	(
		[Folio]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
GO
